package com.kangyi.app.mapper;

import com.kangyi.vo.PublicActivityImgVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author Blank
 * @version 1.0
 */
@Mapper
public interface PublicActivityImgMapper {

    @Select("select image from public_activity_img where public_activity_id = #{id} and sort = 1;")
    String getImage(Integer id);

    @Select("select * from public_activity_img where public_activity_id = #{publicActivityId};")
    List<PublicActivityImgVO> selectByPublicActivityId(Integer id);
}
